package com.system.service;

import com.system.pojo.EmployeeSalary;

import java.util.List;
import java.util.Map;

/**
 * Created by 陈文杰 on 2022/6/6 14:58
 */
public interface EmployeeSalaryService {
    //查询所有员工工资
    List<EmployeeSalary> queryEmployeeSalaryAll();

    //根据主键id查询员工工资
    EmployeeSalary queryEmployeeSalaryByEmpSalId(int empSalId);

    //根据员工id查询员工工资
    EmployeeSalary queryEmployeeSalaryByEmpId(int empId);

    //根据员工姓名查询员工工资
    EmployeeSalary queryEmployeeSalaryByEmpName(String empName);

    //根据部门名查询员工工资
    List<EmployeeSalary> queryEmployeeSalaryByDeptName(String deptName);

    //根据指定的日期查询员工工资
    EmployeeSalary queryEmployeeSalaryByEmpSalDate(String empSalDate);

    //根据指定的日期区间查询员工工资
    EmployeeSalary queryEmployeeSalaryByEmpSalDateSection(String empSalDate1, String empSalDate2);

    //添加员工工资信息
    int addEmployeeSalary(EmployeeSalary employeeSalary);

    //根据主键id修改员工工资
    int updateEmployeeSalaryByEmpSalId(Map<String,Object> map);

    //根据员工id修改员工工资
    int updateEmployeeSalaryByEmpId(Map<String,Object> map);

    //根据员工姓名修改员工工资
    int updateEmployeeSalaryByEmpName(Map<String,Object> map);
    //通过部门名修改员工工资
    int updateEmployeeSalaryByDeptName(Map<String,Object> map);
    //修改工资日期
    int updateEmployeeSalaryDate(String empDate);
    //根据主键id删除员工工资
    int deleteEmployeeSalaryByEmpSalId(int empSalId);

    //根据员工id删除员工工资
    int deleteEmployeeSalaryByEmpId(int empId);

    //根据员工姓名删除员工工资
    int deleteEmployeeSalaryByEmpName(String empName);

    //根据部门名删除员工工资
    int deleteEmployeeSalaryByDeptName(String deptName);

    //根据指定的日期删除员工工资
    int deleteEmployeeSalaryByEmpSalDate(String empSalDate);

    //根据指定的日期区间删除员工工资
    int deleteEmployeeSalaryByEmpSalDateSection(String empSalDate1, String empSalDate2);
}
